Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 31080 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 MiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 10 |
|---|---|
| DateTime | 1 |
| Categorical | 1 |
air_temp is highly overall correlated with clearsky_dhi and 4 other fields | High correlation |
clearsky_dhi is highly overall correlated with air_temp and 6 other fields | High correlation |
clearsky_ghi is highly overall correlated with air_temp and 6 other fields | High correlation |
cloud_opacity is highly overall correlated with clearsky_dhi and 4 other fields | High correlation |
dni is highly overall correlated with air_temp and 6 other fields | High correlation |
ghi is highly overall correlated with air_temp and 6 other fields | High correlation |
hour is highly overall correlated with clearsky_dhi and 4 other fields | High correlation |
relative_humidity is highly overall correlated with air_temp and 4 other fields | High correlation |
period_end has unique values | Unique |
clearsky_dhi has 14427 (46.4%) zeros | Zeros |
clearsky_ghi has 14424 (46.4%) zeros | Zeros |
cloud_opacity has 559 (1.8%) zeros | Zeros |
dni has 19987 (64.3%) zeros | Zeros |
ghi has 14473 (46.6%) zeros | Zeros |
hour has 1295 (4.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-07-25 14:38:55.073358 |
|---|---|
| Analysis finished | 2024-07-25 14:39:03.243305 |
| Duration | 8.17 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
air_temp
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.797394 |
| Minimum | 22 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 22 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 25 |
| median | 26 |
| Q3 | 27 |
| 95-th percentile | 28 |
| Maximum | 31 |
| Range | 9 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5650794 |
|---|---|
| Coefficient of variation (CV) | 0.060668121 |
| Kurtosis | -0.55090953 |
| Mean | 25.797394 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.22307854 |
| Sum | 801783 |
| Variance | 2.4494736 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25 | 7392 | |
| 26 | 6686 | |
| 27 | 5223 | |
| 24 | 5137 | |
| 28 | 3471 | |
| 23 | 1649 | 5.3% |
| 29 | 1274 | 4.1% |
| 30 | 155 | 0.5% |
| 22 | 84 | 0.3% |
| 31 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 22 | 84 | 0.3% |
| 23 | 1649 | 5.3% |
| 24 | 5137 | |
| 25 | 7392 | |
| 26 | 6686 | |
| 27 | 5223 | |
| 28 | 3471 | |
| 29 | 1274 | 4.1% |
| 30 | 155 | 0.5% |
| 31 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 31 | 9 | < 0.1% |
| 30 | 155 | 0.5% |
| 29 | 1274 | 4.1% |
| 28 | 3471 | |
| 27 | 5223 | |
| 26 | 6686 | |
| 25 | 7392 | |
| 24 | 5137 | |
| 23 | 1649 | 5.3% |
| 22 | 84 | 0.3% |
clearsky_dhi
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 273 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.579633 |
| Minimum | 0 |
|---|---|
| Maximum | 343 |
| Zeros | 14427 |
| Zeros (%) | 46.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 10 |
| Q3 | 117 |
| 95-th percentile | 164 |
| Maximum | 343 |
| Range | 343 |
| Interquartile range (IQR) | 117 |
Descriptive statistics
| Standard deviation | 64.273248 |
|---|---|
| Coefficient of variation (CV) | 1.1359785 |
| Kurtosis | -1.1244892 |
| Mean | 56.579633 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.57201951 |
| Sum | 1758495 |
| Variance | 4131.0504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14427 | |
| 125 | 199 | 0.6% |
| 117 | 197 | 0.6% |
| 122 | 195 | 0.6% |
| 126 | 193 | 0.6% |
| 121 | 182 | 0.6% |
| 113 | 180 | 0.6% |
| 116 | 180 | 0.6% |
| 135 | 180 | 0.6% |
| 109 | 180 | 0.6% |
| Other values (263) | 14967 |
| Value | Count | Frequency (%) |
| 0 | 14427 | |
| 1 | 63 | 0.2% |
| 2 | 45 | 0.1% |
| 3 | 171 | 0.6% |
| 4 | 128 | 0.4% |
| 5 | 105 | 0.3% |
| 6 | 105 | 0.3% |
| 7 | 102 | 0.3% |
| 8 | 165 | 0.5% |
| 9 | 144 | 0.5% |
| Value | Count | Frequency (%) |
| 343 | 1 | |
| 337 | 1 | |
| 331 | 1 | |
| 316 | 1 | |
| 314 | 1 | |
| 308 | 1 | |
| 298 | 1 | |
| 294 | 1 | |
| 290 | 1 | |
| 278 | 1 |
clearsky_ghi
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 1022 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 284.36075 |
| Minimum | 0 |
|---|---|
| Maximum | 1024 |
| Zeros | 14424 |
| Zeros (%) | 46.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14 |
| Q3 | 630 |
| 95-th percentile | 937 |
| Maximum | 1024 |
| Range | 1024 |
| Interquartile range (IQR) | 630 |
Descriptive statistics
| Standard deviation | 359.30817 |
|---|---|
| Coefficient of variation (CV) | 1.2635646 |
| Kurtosis | -1.063813 |
| Mean | 284.36075 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.77936274 |
| Sum | 8837932 |
| Variance | 129102.36 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14424 | |
| 4 | 154 | 0.5% |
| 10 | 122 | 0.4% |
| 5 | 107 | 0.3% |
| 11 | 106 | 0.3% |
| 17 | 83 | 0.3% |
| 8 | 76 | 0.2% |
| 9 | 73 | 0.2% |
| 16 | 72 | 0.2% |
| 7 | 71 | 0.2% |
| Other values (1012) | 15792 |
| Value | Count | Frequency (%) |
| 0 | 14424 | |
| 1 | 61 | 0.2% |
| 2 | 39 | 0.1% |
| 3 | 69 | 0.2% |
| 4 | 154 | 0.5% |
| 5 | 107 | 0.3% |
| 6 | 68 | 0.2% |
| 7 | 71 | 0.2% |
| 8 | 76 | 0.2% |
| 9 | 73 | 0.2% |
| Value | Count | Frequency (%) |
| 1024 | 1 | < 0.1% |
| 1022 | 1 | < 0.1% |
| 1020 | 4 | |
| 1019 | 1 | < 0.1% |
| 1018 | 2 | < 0.1% |
| 1017 | 4 | |
| 1016 | 4 | |
| 1015 | 4 | |
| 1013 | 6 | |
| 1012 | 2 | < 0.1% |
cloud_opacity
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 971 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.12881 |
| Minimum | 0 |
|---|---|
| Maximum | 97 |
| Zeros | 559 |
| Zeros (%) | 1.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.5 |
| Q1 | 32.1 |
| median | 50.1 |
| Q3 | 70.3 |
| 95-th percentile | 92.9 |
| Maximum | 97 |
| Range | 97 |
| Interquartile range (IQR) | 38.2 |
Descriptive statistics
| Standard deviation | 26.132621 |
|---|---|
| Coefficient of variation (CV) | 0.52130943 |
| Kurtosis | -0.84359185 |
| Mean | 50.12881 |
| Median Absolute Deviation (MAD) | 19.1 |
| Skewness | -0.094955302 |
| Sum | 1558003.4 |
| Variance | 682.9139 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 559 | 1.8% |
| 97 | 110 | 0.4% |
| 96.9 | 71 | 0.2% |
| 96.8 | 69 | 0.2% |
| 40.1 | 68 | 0.2% |
| 37.8 | 63 | 0.2% |
| 46.1 | 63 | 0.2% |
| 44.1 | 63 | 0.2% |
| 47.5 | 62 | 0.2% |
| 52.7 | 62 | 0.2% |
| Other values (961) | 29890 |
| Value | Count | Frequency (%) |
| 0 | 559 | |
| 0.1 | 29 | 0.1% |
| 0.2 | 32 | 0.1% |
| 0.3 | 33 | 0.1% |
| 0.4 | 26 | 0.1% |
| 0.5 | 31 | 0.1% |
| 0.6 | 29 | 0.1% |
| 0.7 | 26 | 0.1% |
| 0.8 | 20 | 0.1% |
| 0.9 | 18 | 0.1% |
| Value | Count | Frequency (%) |
| 97 | 110 | |
| 96.9 | 71 | |
| 96.8 | 69 | |
| 96.7 | 43 | 0.1% |
| 96.6 | 36 | 0.1% |
| 96.5 | 35 | 0.1% |
| 96.4 | 30 | 0.1% |
| 96.3 | 22 | 0.1% |
| 96.2 | 36 | 0.1% |
| 96.1 | 38 | 0.1% |
dni
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 887 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.31219 |
| Minimum | 0 |
|---|---|
| Maximum | 924 |
| Zeros | 19987 |
| Zeros (%) | 64.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 92 |
| 95-th percentile | 593 |
| Maximum | 924 |
| Range | 924 |
| Interquartile range (IQR) | 92 |
Descriptive statistics
| Standard deviation | 196.47962 |
|---|---|
| Coefficient of variation (CV) | 1.9393481 |
| Kurtosis | 3.0266585 |
| Mean | 101.31219 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0144346 |
| Sum | 3148783 |
| Variance | 38604.239 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19987 | |
| 1 | 143 | 0.5% |
| 2 | 110 | 0.4% |
| 3 | 109 | 0.4% |
| 5 | 93 | 0.3% |
| 7 | 88 | 0.3% |
| 6 | 86 | 0.3% |
| 4 | 84 | 0.3% |
| 10 | 67 | 0.2% |
| 13 | 64 | 0.2% |
| Other values (877) | 10249 |
| Value | Count | Frequency (%) |
| 0 | 19987 | |
| 1 | 143 | 0.5% |
| 2 | 110 | 0.4% |
| 3 | 109 | 0.4% |
| 4 | 84 | 0.3% |
| 5 | 93 | 0.3% |
| 6 | 86 | 0.3% |
| 7 | 88 | 0.3% |
| 8 | 62 | 0.2% |
| 9 | 58 | 0.2% |
| Value | Count | Frequency (%) |
| 924 | 1 | |
| 914 | 1 | |
| 913 | 1 | |
| 909 | 1 | |
| 908 | 1 | |
| 903 | 1 | |
| 898 | 1 | |
| 897 | 1 | |
| 894 | 2 | |
| 893 | 2 |
ghi
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 994 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 192.26097 |
| Minimum | 0 |
|---|---|
| Maximum | 1020 |
| Zeros | 14473 |
| Zeros (%) | 46.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 8 |
| Q3 | 377 |
| 95-th percentile | 729 |
| Maximum | 1020 |
| Range | 1020 |
| Interquartile range (IQR) | 377 |
Descriptive statistics
| Standard deviation | 260.54918 |
|---|---|
| Coefficient of variation (CV) | 1.355185 |
| Kurtosis | -0.068249976 |
| Mean | 192.26097 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.1091107 |
| Sum | 5975471 |
| Variance | 67885.875 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14473 | |
| 2 | 188 | 0.6% |
| 3 | 185 | 0.6% |
| 1 | 161 | 0.5% |
| 6 | 145 | 0.5% |
| 5 | 144 | 0.5% |
| 4 | 125 | 0.4% |
| 7 | 112 | 0.4% |
| 8 | 108 | 0.3% |
| 9 | 87 | 0.3% |
| Other values (984) | 15352 |
| Value | Count | Frequency (%) |
| 0 | 14473 | |
| 1 | 161 | 0.5% |
| 2 | 188 | 0.6% |
| 3 | 185 | 0.6% |
| 4 | 125 | 0.4% |
| 5 | 144 | 0.5% |
| 6 | 145 | 0.5% |
| 7 | 112 | 0.4% |
| 8 | 108 | 0.3% |
| 9 | 87 | 0.3% |
| Value | Count | Frequency (%) |
| 1020 | 2 | |
| 1017 | 1 | |
| 1010 | 1 | |
| 1007 | 1 | |
| 1006 | 2 | |
| 1004 | 1 | |
| 1003 | 1 | |
| 997 | 1 | |
| 992 | 1 | |
| 990 | 1 |
relative_humidity
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 382 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 84.056641 |
| Minimum | 54.6 |
|---|---|
| Maximum | 99.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 242.9 KiB |
Quantile statistics
| Minimum | 54.6 |
|---|---|
| 5-th percentile | 71.6 |
| Q1 | 79.5 |
| median | 84.8 |
| Q3 | 89.5 |
| 95-th percentile | 93.8 |
| Maximum | 99.7 |
| Range | 45.1 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.8821231 |
|---|---|
| Coefficient of variation (CV) | 0.081874829 |
| Kurtosis | -0.17130728 |
| Mean | 84.056641 |
| Median Absolute Deviation (MAD) | 4.9 |
| Skewness | -0.52657475 |
| Sum | 2612480.4 |
| Variance | 47.363619 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 92.2 | 297 | 1.0% |
| 92.5 | 295 | 0.9% |
| 93.6 | 270 | 0.9% |
| 91.4 | 269 | 0.9% |
| 91.7 | 261 | 0.8% |
| 93.3 | 261 | 0.8% |
| 91.1 | 260 | 0.8% |
| 87.2 | 232 | 0.7% |
| 92.8 | 231 | 0.7% |
| 93.9 | 231 | 0.7% |
| Other values (372) | 28473 |
| Value | Count | Frequency (%) |
| 54.6 | 1 | |
| 54.9 | 2 | |
| 55.3 | 1 | |
| 55.4 | 1 | |
| 56.6 | 1 | |
| 57 | 1 | |
| 57.5 | 1 | |
| 58.1 | 2 | |
| 58.3 | 2 | |
| 58.5 | 1 |
| Value | Count | Frequency (%) |
| 99.7 | 1 | < 0.1% |
| 99.1 | 1 | < 0.1% |
| 98.8 | 3 | < 0.1% |
| 98.5 | 3 | < 0.1% |
| 98.2 | 12 | |
| 97.9 | 8 | |
| 97.6 | 14 | |
| 97.4 | 5 | < 0.1% |
| 97.3 | 14 | |
| 97.1 | 11 |
period_end
Date
UNIQUE 
| Distinct | 31080 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 242.9 KiB |
| Minimum | 2021-01-01 01:00:00+00:00 |
|---|---|
| Maximum | 2024-07-19 00:00:00+00:00 |
year
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 MiB |
| 2022 | |
|---|---|
| 2023 | |
| 2021 | |
| 2024 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 124320 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2021 |
|---|---|
| 2nd row | 2021 |
| 3rd row | 2021 |
| 4th row | 2021 |
| 5th row | 2021 |
Common Values
| Value | Count | Frequency (%) |
| 2022 | 8760 | |
| 2023 | 8760 | |
| 2021 | 8759 | |
| 2024 | 4801 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022 | 8760 | |
| 2023 | 8760 | |
| 2021 | 8759 | |
| 2024 | 4801 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 70920 | |
| 0 | 31080 | |
| 3 | 8760 | 7.0% |
| 1 | 8759 | 7.0% |
| 4 | 4801 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 124320 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 70920 | |
| 0 | 31080 | |
| 3 | 8760 | 7.0% |
| 1 | 8759 | 7.0% |
| 4 | 4801 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 124320 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 70920 | |
| 0 | 31080 | |
| 3 | 8760 | 7.0% |
| 1 | 8759 | 7.0% |
| 4 | 4801 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 124320 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 70920 | |
| 0 | 31080 | |
| 3 | 8760 | 7.0% |
| 1 | 8759 | 7.0% |
| 4 | 4801 | 3.9% |
month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.107529 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 121.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.402419 |
|---|---|
| Coefficient of variation (CV) | 0.55708601 |
| Kurtosis | -1.1373652 |
| Mean | 6.107529 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.16820227 |
| Sum | 189822 |
| Variance | 11.576455 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 2976 | |
| 5 | 2976 | |
| 1 | 2975 | |
| 4 | 2880 | |
| 6 | 2880 | |
| 2 | 2712 | |
| 7 | 2665 | |
| 8 | 2232 | |
| 10 | 2232 | |
| 12 | 2232 | |
| Other values (2) | 4320 |
| Value | Count | Frequency (%) |
| 1 | 2975 | |
| 2 | 2712 | |
| 3 | 2976 | |
| 4 | 2880 | |
| 5 | 2976 | |
| 6 | 2880 | |
| 7 | 2665 | |
| 8 | 2232 | |
| 9 | 2160 | |
| 10 | 2232 |
| Value | Count | Frequency (%) |
| 12 | 2232 | |
| 11 | 2160 | |
| 10 | 2232 | |
| 9 | 2160 | |
| 8 | 2232 | |
| 7 | 2665 | |
| 6 | 2880 | |
| 5 | 2976 | |
| 4 | 2880 | |
| 3 | 2976 |
day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.628378 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 121.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7821938 |
|---|---|
| Coefficient of variation (CV) | 0.5619389 |
| Kurtosis | -1.1891113 |
| Mean | 15.628378 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.021490321 |
| Sum | 485730 |
| Variance | 77.126927 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 1032 | 3.3% |
| 10 | 1032 | 3.3% |
| 2 | 1032 | 3.3% |
| 15 | 1032 | 3.3% |
| 14 | 1032 | 3.3% |
| 13 | 1032 | 3.3% |
| 12 | 1032 | 3.3% |
| 11 | 1032 | 3.3% |
| 9 | 1032 | 3.3% |
| 18 | 1032 | 3.3% |
| Other values (21) | 20760 |
| Value | Count | Frequency (%) |
| 1 | 1031 | |
| 2 | 1032 | |
| 3 | 1032 | |
| 4 | 1032 | |
| 5 | 1032 | |
| 6 | 1032 | |
| 7 | 1032 | |
| 8 | 1032 | |
| 9 | 1032 | |
| 10 | 1032 |
| Value | Count | Frequency (%) |
| 31 | 576 | |
| 30 | 912 | |
| 29 | 936 | |
| 28 | 1008 | |
| 27 | 1008 | |
| 26 | 1008 | |
| 25 | 1008 | |
| 24 | 1008 | |
| 23 | 1008 | |
| 22 | 1008 |
hour
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 1295 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 121.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9222979 |
|---|---|
| Coefficient of variation (CV) | 0.60193895 |
| Kurtosis | -1.2041746 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 357420 |
| Variance | 47.918208 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1295 | 4.2% |
| 2 | 1295 | 4.2% |
| 23 | 1295 | 4.2% |
| 22 | 1295 | 4.2% |
| 21 | 1295 | 4.2% |
| 20 | 1295 | 4.2% |
| 19 | 1295 | 4.2% |
| 18 | 1295 | 4.2% |
| 17 | 1295 | 4.2% |
| 16 | 1295 | 4.2% |
| Other values (14) | 18130 |
| Value | Count | Frequency (%) |
| 0 | 1295 | |
| 1 | 1295 | |
| 2 | 1295 | |
| 3 | 1295 | |
| 4 | 1295 | |
| 5 | 1295 | |
| 6 | 1295 | |
| 7 | 1295 | |
| 8 | 1295 | |
| 9 | 1295 |
| Value | Count | Frequency (%) |
| 23 | 1295 | |
| 22 | 1295 | |
| 21 | 1295 | |
| 20 | 1295 | |
| 19 | 1295 | |
| 18 | 1295 | |
| 17 | 1295 | |
| 16 | 1295 | |
| 15 | 1295 | |
| 14 | 1295 |
| air_temp | clearsky_dhi | clearsky_ghi | cloud_opacity | day | dni | ghi | hour | month | relative_humidity | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| air_temp | 1.000 | 0.610 | 0.640 | -0.453 | 0.018 | 0.546 | 0.648 | 0.463 | -0.159 | -0.652 | 0.227 |
| clearsky_dhi | 0.610 | 1.000 | 0.968 | -0.593 | -0.001 | 0.705 | 0.952 | 0.784 | -0.008 | -0.572 | 0.056 |
| clearsky_ghi | 0.640 | 0.968 | 1.000 | -0.602 | -0.000 | 0.730 | 0.976 | 0.784 | -0.013 | -0.591 | 0.025 |
| cloud_opacity | -0.453 | -0.593 | -0.602 | 1.000 | 0.017 | -0.810 | -0.704 | -0.526 | -0.067 | 0.497 | 0.040 |
| day | 0.018 | -0.001 | -0.000 | 0.017 | 1.000 | 0.001 | 0.001 | -0.000 | 0.007 | 0.004 | 0.000 |
| dni | 0.546 | 0.705 | 0.730 | -0.810 | 0.001 | 1.000 | 0.834 | 0.658 | -0.000 | -0.508 | 0.036 |
| ghi | 0.648 | 0.952 | 0.976 | -0.704 | 0.001 | 0.834 | 1.000 | 0.789 | -0.010 | -0.599 | 0.028 |
| hour | 0.463 | 0.784 | 0.784 | -0.526 | -0.000 | 0.658 | 0.789 | 1.000 | -0.000 | -0.414 | 0.000 |
| month | -0.159 | -0.008 | -0.013 | -0.067 | 0.007 | -0.000 | -0.010 | -0.000 | 1.000 | -0.267 | 0.186 |
| relative_humidity | -0.652 | -0.572 | -0.591 | 0.497 | 0.004 | -0.508 | -0.599 | -0.414 | -0.267 | 1.000 | 0.095 |
| year | 0.227 | 0.056 | 0.025 | 0.040 | 0.000 | 0.036 | 0.028 | 0.000 | 0.186 | 0.095 | 1.000 |
| air_temp | clearsky_dhi | clearsky_ghi | cloud_opacity | dni | ghi | relative_humidity | period_end | year | month | day | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 25 | 0 | 0 | 86.6 | 0 | 0 | 82.4 | 2021-01-01 01:00:00+00:00 | 2021 | 1 | 1 | 1 |
| 1 | 25 | 0 | 0 | 65.0 | 0 | 0 | 82.9 | 2021-01-01 02:00:00+00:00 | 2021 | 1 | 1 | 2 |
| 2 | 24 | 0 | 0 | 65.1 | 0 | 0 | 83.1 | 2021-01-01 03:00:00+00:00 | 2021 | 1 | 1 | 3 |
| 3 | 24 | 0 | 0 | 52.7 | 0 | 0 | 82.8 | 2021-01-01 04:00:00+00:00 | 2021 | 1 | 1 | 4 |
| 4 | 24 | 0 | 0 | 54.7 | 0 | 0 | 83.1 | 2021-01-01 05:00:00+00:00 | 2021 | 1 | 1 | 5 |
| 5 | 24 | 0 | 0 | 59.9 | 0 | 0 | 83.3 | 2021-01-01 06:00:00+00:00 | 2021 | 1 | 1 | 6 |
| 6 | 24 | 0 | 0 | 72.0 | 0 | 0 | 83.6 | 2021-01-01 07:00:00+00:00 | 2021 | 1 | 1 | 7 |
| 7 | 24 | 0 | 0 | 53.3 | 0 | 0 | 84.1 | 2021-01-01 08:00:00+00:00 | 2021 | 1 | 1 | 8 |
| 8 | 24 | 0 | 0 | 75.4 | 0 | 0 | 84.4 | 2021-01-01 09:00:00+00:00 | 2021 | 1 | 1 | 9 |
| 9 | 24 | 0 | 0 | 81.2 | 0 | 0 | 84.6 | 2021-01-01 10:00:00+00:00 | 2021 | 1 | 1 | 10 |
| air_temp | clearsky_dhi | clearsky_ghi | cloud_opacity | dni | ghi | relative_humidity | period_end | year | month | day | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31070 | 25 | 114 | 616 | 10.0 | 519 | 550 | 80.2 | 2024-07-18 15:00:00+00:00 | 2024 | 7 | 18 | 15 |
| 31071 | 25 | 122 | 775 | 31.4 | 133 | 531 | 78.1 | 2024-07-18 16:00:00+00:00 | 2024 | 7 | 18 | 16 |
| 31072 | 26 | 129 | 873 | 18.6 | 389 | 712 | 78.3 | 2024-07-18 17:00:00+00:00 | 2024 | 7 | 18 | 17 |
| 31073 | 25 | 128 | 904 | 16.5 | 434 | 754 | 79.3 | 2024-07-18 18:00:00+00:00 | 2024 | 7 | 18 | 18 |
| 31074 | 26 | 125 | 863 | 7.4 | 636 | 799 | 78.8 | 2024-07-18 19:00:00+00:00 | 2024 | 7 | 18 | 19 |
| 31075 | 26 | 121 | 753 | 3.2 | 710 | 729 | 78.4 | 2024-07-18 20:00:00+00:00 | 2024 | 7 | 18 | 20 |
| 31076 | 26 | 112 | 585 | 6.2 | 586 | 547 | 78.6 | 2024-07-18 21:00:00+00:00 | 2024 | 7 | 18 | 21 |
| 31077 | 25 | 96 | 376 | 5.5 | 501 | 354 | 79.3 | 2024-07-18 22:00:00+00:00 | 2024 | 7 | 18 | 22 |
| 31078 | 25 | 61 | 154 | 10.4 | 243 | 141 | 81.2 | 2024-07-18 23:00:00+00:00 | 2024 | 7 | 18 | 23 |
| 31079 | 24 | 8 | 10 | 39.0 | 2 | 8 | 83.6 | 2024-07-19 00:00:00+00:00 | 2024 | 7 | 19 | 0 |